Link not updating when set to auto update due to cleared option.
Cause:
The 'Update Remote Reference' check box has not been selected in the 'Options' dialog box.
Solution:
Select 'Options...' from the 'Tools' menu and select the 'Update Remote Reference' check box.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click 'Calculation' tab.
3) Select the 'Update Remote Reference' check box in the 'Workbook Options' group.
the Update Remote Reference check box
4) Click 'OK'.
